package com.nl.controller.sms5g.mapper;

import com.nl.controller.sms5g.bean.Sms5gTemplateInfo;
import com.nl.controller.sms5g.bean.UploadFileInfo;
import com.nl.controller.sms5g.bean.bo.CreateMgrSignRelBo;
import com.nl.controller.sms5g.bean.bo.CreateSendRangeBo;
import com.nl.controller.sms5g.bean.bo.CreateUploadRecordBo;
import com.nl.controller.sms5g.bean.bo.UpdateMgrSignRelBo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @desc 5g多媒体模板
 * @return null
 * @author l
 * @date 2021/6/10 15:58
 */
@Mapper
public interface Sms5gTemplateMapper {
    /**
     * aa
     * @desc 添加上传记录
     * @param createUploadRecordBo
     * @return int
     * @author l
     * @date 2021/6/8 17:32
     */
    int createUploadRecord(CreateUploadRecordBo createUploadRecordBo);

    /**
     * aa
     * @desc 删除上传记录
     * @param mgrId
     * @param fileName
     * @return int
     * @author l
     * @date 2021/6/8 17:56
     */
    int deleteUploadRecord(@Param(value = "mgrId") String mgrId, @Param("fileName") String fileName);

    /**
     * aa
     * @desc 查询项目上传文件列表
     * @param mgrId
     * @return java.util.List<com.nl.controller.sms5g.bean.UploadFileInfo>
     * @author l
     * @date 2021/6/9 11:00
     */
    List<UploadFileInfo> qryUploadFileInfoList(String mgrId);

    /**
     * 变更
     * @param mgrId
     * @param fileName
     * @param orderId
     * @return
     */
    int update5gTemplateOrder(@Param(value = "mgrId")String mgrId, @Param(value = "fileName")String fileName, @Param(value = "orderId")int orderId);
    
    /**
     * @desc 查询5g多媒体模板信息
     * @param mgrId 
     * @return com.nl.controller.sms5g.bean.Sms5gTemplateInfo
     * @author l
     * @date 2021/6/10 17:15
     */
    Sms5gTemplateInfo qry5gTemplateInfo(String mgrId);

    /**
     * aaa
     * @desc 变更项目对应5g平台的模板编码
     * @param mgrId
     * @param modeId
     * @return int
     * @author l
     * @date 2021/6/10 20:12
     */
    int updateMgrModeId(@Param(value = "mgrId")String mgrId,@Param(value = "modeId")String modeId);

    /**
     * @desc 查询未审核5g模板编码
     * @return java.util.List<java.lang.String>
     * @author l
     * @date 2021/6/11 15:51
     */
    List<String> qryUncheckedTemplate();
    /**
     * @desc 变更5G模板审核状态
     * @param modeId 
     * @param checkResult
     * @return int
     * @author l
     * @date 2021/6/17 16:18
     */
    int updateModeCheckState(@Param(value = "modeId")String modeId,@Param(value = "checkResult")String checkResult,@Param(value = "checkReason")String checkReason);
    
    /**
     * @desc 新建项目发送范围
     * @param createSendRangeBo 
     * @return int
     * @author l
     * @date 2021/6/17 16:33
     */
    int createSendRange(CreateSendRangeBo createSendRangeBo);

    int createMgrSignRel(CreateMgrSignRelBo createMgrSignRelBo);

    int updateMgrSignRel(UpdateMgrSignRelBo updateMgrSignRelBo);
}
